﻿CREATE PROCEDURE [dbo].[GetSUPSRows]
	@startRowIndex int,
	@maximumRows int
AS

	Select
		Cargo_ID,
		Name,
		Description,
		ShortCode,
		Code,
		CodeGNG,
		Mnemocode,
		IsUsed,
		IsEmpty
	FROM
		(
		SELECT *,ROW_NUMBER() OVER (ORDER BY Cargo_ID) AS RowRank
        FROM Cargo) AS myCargo
			WHERE RowRank > @startRowIndex AND RowRank <= (@startRowIndex + @maximumRows)
RETURN 0
